Contents:
|
Installing MySQL©:
To install MySQL database server software on a Mac running OS X 10.4 or higher, first go to the MySQL 5.1 download web page. Scroll down and click on "Mac OS X (package format)". Then download the appropriate package format dmg file. If you are running OS X 10.4 (Tiger) you should download either the "Mac OS X 10.4 (PowerPC, 32 bit)" package or the "Mac OS X 10.4 (x86)" package, depending on whether you have a PowerPC Mac or an Intel mac. If you are running OS X 10.5 (Leopard) you should download either the "Mac OS X 10.5 (PowerPC, 32 bit)" package or the "Mac OS X 10.5 (x86)" package, again depending on what Mac hardware you have. Then, to install, open the .dmg file and double-click on the .pkg file for the version of MySQL that you downloaded, as you would with any Mac software package. The ReadMe.txt file has detailed instructions. There is also a System Preferences panel called "MySQL.prefPane". Double-click on this and it will install itself in the System Preferences. You can then use it to stop and start the MySQL server. Initially, the MySQL server software has a user named 'root'. Note that this has nothing to do with your computer's 'root' user. It is entirely separate. This is not your system root user. It is just the MySQL root user. Although it is not required, it is a good idea to assign a password to the MySQL root user. To assign a password for the root user, first make sure that the MySQL server is running by going to your System Preferences and clicking on the MySQL preference pane that you just installed. If the MySQL server is not already running, click to start it. Then open a terminal window, and type the following two statements on the command line. cd /usr/local/mysql/bin ./mysqladmin -u root password 'new-password'where "new-password" is your chosen MySQL root password. If you are upgrading to MailSteward Pro from MailSteward, you can move all of your archived email over to the Pro version by following these steps: 1. In MailSteward, do a Browse to list all of the email in your database. 2. Choose "SQL file..." from the Export drop-down. 3. Choose a file name for the exported SQL file that will be the name of the MySQL database that will either be created or added to. 4. In MailSteward Pro, choose "Import MailSteward SQL File..." from the File menu, and select the SQL file that you just exported from MailSteward. All of the email that you exported from MailSteward will now be in the MySQL database with the same name as the exported SQL file, minus the .sql extension. There is an excellent open source Mac Cocoa MySQL management program called Sequel Pro, which can be obtained here. You can use this software to view and edit any MySQL database, including a MailSteward MySQL database. If you use it, send the developer a donation. |